﻿CREATE TABLE [dbo].[CalculSporuri] (
    [IDSporPersoana]      INT             IDENTITY (0, 1) NOT NULL,
    [Valoare]             DECIMAL (18, 2) NULL,
    [ValoareCo]           DECIMAL (18, 2) NULL,
    [ValoareInt]          DECIMAL (18, 2) NULL,
    [Procent]             DECIMAL (6, 2)  NULL,
    [ValoarePreaviz]      DECIMAL (18, 2) NULL,
    [IdTipSpor]           INT             NOT NULL,
    [IdPersoana]          INT             NOT NULL,
    [IDAngajatSalarizare] INT             NOT NULL,
    [Anul]                SMALLINT        CONSTRAINT [DF_CalculSporuri_Anul] DEFAULT ((2000)) NOT NULL,
    [Luna]                SMALLINT        CONSTRAINT [DF_CalculSporuri_Luna] DEFAULT ((1)) NOT NULL,
    [PanaLaData]          DATETIME        NULL,
    CONSTRAINT [PK_CalculSporuri] PRIMARY KEY CLUSTERED ([IDSporPersoana] ASC),
    CONSTRAINT [FK_CalculSporuri_Persoane] FOREIGN KEY ([IdPersoana]) REFERENCES [dbo].[Persoane] ([IdPersoana])
);

